Exploratory Data Analysis Step
20 August 2024
Analysis Plan
#> no calculated indicators has been defined...Automatic Exploration
Group
Enumerator Name
plot_text(datalist, dico, "group_sg8tr67.enumerator_name", datasource=params$datasource)
Organization
plot_text(datalist, dico, "group_sg8tr67.organization", datasource=params$datasource)
Do you agree to participate in this survey?
plot_select_one(datalist, dico, "group_sg8tr67.consent", datasource = params$datasource, n = 5)
——
Group
What is your age group?
plot_select_one(datalist, dico, "group_xt46l40.age_group", datasource = params$datasource, n = 5)
What is your gender?
plot_select_one(datalist, dico, "group_xt46l40.gender", datasource = params$datasource, n = 5)
No
significant text for the question:
group_xt46l40.If_Other_Please_specifyNULL
What is your marital status?
plot_select_one(datalist, dico, "group_xt46l40.marital_status", datasource = params$datasource, n = 5)
What is your highest level of education?
plot_select_one(datalist, dico, "group_xt46l40.education_level", datasource = params$datasource, n = 5)
Household Composition:
plot_select_one(datalist, dico, "group_xt46l40.household_composition", datasource = params$datasource, n = 5)
If Other ? Pleas specify.
plot_text(datalist, dico, "group_xt46l40.HH_Composition_Other", datasource=params$datasource)
What clan do you belong to?
plot_select_one(datalist, dico, "group_xt46l40.clan", datasource = params$datasource, n = 5)
If Other ? Please specify..
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_001", datasource=params$datasource)
6. In which region does the household reside?
plot_select_one(datalist, dico, "group_xt46l40.region", datasource = params$datasource, n = 5)
7. In which district does the household reside?
plot_select_one(datalist, dico, "group_xt46l40.district", datasource = params$datasource, n = 5)
Who
are the individuals/groups in your community that are most vulnerable
plot_select_multiple(datalist, dico, "group_xt46l40.vulnerable_groups", datasource=params$datasource, n=5)
If Others? Please specify
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_specify", datasource=params$datasource)
Select
all that apply (Women at Risk)
plot_select_multiple(datalist, dico, "group_xt46l40.vulnerable_groups_war", datasource=params$datasource, n=5)
If Others ? Please specify (For Women at Risk - Other)
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_s_omen_at_Risk_Other", datasource=params$datasource)
Select
all that apply (Child at Risk)
plot_select_multiple(datalist, dico, "group_xt46l40.vulnerable_groups_car", datasource=params$datasource, n=5)
If Others ? Please specify (For Child at Risk - Other)
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_s_hild_at_Risk_Other", datasource=params$datasource)
Iindividuals/groups
in community at risk of excluded from assistance
plot_select_multiple(datalist, dico, "group_xt46l40.at_risk_groups", datasource=params$datasource, n=5)
If Others? Please specify
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_specify_001", datasource=params$datasource)
Select
all that apply (Women at Risk)
plot_select_multiple(datalist, dico, "group_xt46l40.at_risk_groups_war", datasource=params$datasource, n=5)
If Others ? Please specify (For Women at Risk - Other)
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_s_omen_at_Risk_Other_001", datasource=params$datasource)
Select
all that apply (Child at Risk)
plot_select_multiple(datalist, dico, "group_xt46l40.at_risk_groups_car", datasource=params$datasource, n=5)
No
significant text for the question:
group_xt46l40.If_Others_Please_s_hild_at_Risk_Other_001NULL
Have these at-risk individuals/groups received adequate humanitarian
assistance
plot_select_one(datalist, dico, "group_xt46l40.adequate_assistance", datasource = params$datasource, n = 5)
What
kind of support have they received from the humanitarian partners
plot_select_multiple(datalist, dico, "group_xt46l40.assistance_received", datasource=params$datasource, n=5)
Use CE, gate keepers, community elders, religious elders in providing
assitance
plot_select_one(datalist, dico, "group_xt46l40.community_leaders_assistance", datasource = params$datasource, n = 5)
Challenges
receiving HA from the community leaders, gate keepers, CE, CA
plot_select_multiple(datalist, dico, "group_xt46l40.challenges", datasource=params$datasource, n=5)
If Other ? Please specify.
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_002", datasource=params$datasource)
You
selected - Abuse and exploitation, who is committing the incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_Abuse_and_exploit", datasource=params$datasource, n=5)
If Others (Abuse and exploitation)
plot_text(datalist, dico, "group_xt46l40.If_Others_Abuse_and_exploitation", datasource=params$datasource)
You
selected - Aid Diversion, who is committing the incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_Aid_Diversion", datasource=params$datasource, n=5)
If Others (Aid Diversion)
plot_text(datalist, dico, "group_xt46l40.If_Others_Aid_Diversion", datasource=params$datasource)
You
selected - Corruption, who is committing the incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_corruption", datasource=params$datasource, n=5)
If Others (Corruption)
plot_text(datalist, dico, "group_xt46l40.If_Others_Abuse_and_exploitation_001", datasource=params$datasource)
You
selected - Discrimination, who is committing the incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_discrimination", datasource=params$datasource, n=5)
If Others (Discrimination)
plot_text(datalist, dico, "group_xt46l40.If_Others_Discrimination", datasource=params$datasource)
You
selected - Harassment and intimidation, who is committing the
incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_harassment_intimidation", datasource=params$datasource, n=5)
If Others (Harassmenta and Intimidation)
plot_text(datalist, dico, "group_xt46l40.If_Others_harassment_intimidation", datasource=params$datasource)
You
selected - Lack of information, who is committing the incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_lack_of_information", datasource=params$datasource, n=5)
If Others (Lack of information)
plot_text(datalist, dico, "group_xt46l40.If_Others_lack_of_information", datasource=params$datasource)
You
selected - Security concerns, who is committing the incidences?
plot_select_multiple(datalist, dico, "group_xt46l40.perpetrators_security_concerns", datasource=params$datasource, n=5)
If Others (Security concerns)
plot_text(datalist, dico, "group_xt46l40.If_Others_security_concerns", datasource=params$datasource)
——
(group_xt46l40.How_effective_do_you_denial_of_assistance.How_effective_do_you_denial_of_assistance)
The variable from the form called: group_xt46l40.How_effective_do_you_denial_of_assistance.How_effective_do_you_denial_of_assistance_header could not be identified in the dataset
NULL
Prioritizing at risk of exclusion from assistance, such as the
minority groups
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.a_Prioritizing_thos_the_minority_groups", datasource = params$datasource, n = 5)
b. Beneficiary selection based on their vulnerability.
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.b_Beneficiary_selec_their_vulnerability", datasource = params$datasource, n = 5)
Training on protection, inclusivity and equality.
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.c_Targeting_gatekee_usivity_and_equality", datasource = params$datasource, n = 5)
d. Reporting mechanism on cases of exclusion, aid diversion, corruption,
fraud
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.d_Reporting_mechani_n_corruption_fraud", datasource = params$datasource, n = 5)
Reporting mechanism on cases of harassment, intimidation, abuse,
exploi& abuse
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.e_Reporting_mechani_tion_and_corruption", datasource = params$datasource, n = 5)
f. Partners/Organizations field presence that engages the community
directly
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.f_Partners_Organiza_e_community_directly", datasource = params$datasource, n = 5)
Direct channels of communication with the community on beneficiary
entitlement
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.g_Partners_Organiza_ciary_entitlement_on", datasource = params$datasource, n = 5)
h. Working with community structures such as community committees or
community
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.h_Working_with_comm_mittees_or_community", datasource = params$datasource, n = 5)
Sharing key messages reporting abuse and exploitation.
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.i_Partners_Organiza_use_and_exploitation", datasource = params$datasource, n = 5)
Sharing key messages on inclusion, fraud, aid diversion, corruption.
plot_select_one(datalist, dico, "group_xt46l40.How_effective_do_you_denial_of_assistance.j_Partners_Organiza_iversion_corruption", datasource = params$datasource, n = 5)
If you answered either of the above, state your overall reasons why?
plot_text(datalist, dico, "group_xt46l40.reasons_for_effectiveness", datasource=params$datasource)
Ensure the affected population are not excluded or denied assistance
plot_text(datalist, dico, "group_xt46l40.recommendations_engagement", datasource=params$datasource)
Engagement with you/community prior on program dev. or distribution
design
plot_select_one(datalist, dico, "group_xt46l40.engagement_frequency", datasource = params$datasource, n = 5)
Believe partners/organizations program or distribution beneficiaries
fairly
plot_select_one(datalist, dico, "group_xt46l40.fairness_selection", datasource = params$datasource, n = 5)
Receive the expected package/resources from partners/organizations?
plot_select_one(datalist, dico, "group_xt46l40.assistance_received_001", datasource = params$datasource, n = 5)
Know where to lodge a complaint or provide feedback to a humanitarian
actor?
plot_select_one(datalist, dico, "group_xt46l40.complaint_lodging", datasource = params$datasource, n = 5)
What do you do as a community to assist those excluded or denied
assistance?
plot_text(datalist, dico, "group_xt46l40.community_assistance", datasource=params$datasource)
Most
significant risks faced by displaced individuals/groups in your
community
plot_select_multiple(datalist, dico, "group_xt46l40.displacement_risks", datasource=params$datasource, n=5)
If Others. Please specify.
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_specify_002", datasource=params$datasource)
Give the reasons for the selected protection risks?
plot_text(datalist, dico, "group_xt46l40.reasons_for_risks", datasource=params$datasource)
Positive Coping Mechanism
plot_text(datalist, dico, "group_xt46l40.positive_coping", datasource=params$datasource)
Negative Coping Mechnism
plot_text(datalist, dico, "group_xt46l40.negative_coping", datasource=params$datasource)
Type
of platforms accessible
plot_select_multiple(datalist, dico, "group_xt46l40.info_platforms", datasource=params$datasource, n=5)
If Others ? Please specify.
plot_text(datalist, dico, "group_xt46l40.If_Others_Please_specify_003", datasource=params$datasource)
Are there any programs in place to address negative coping mechanisms
plot_select_one(datalist, dico, "group_xt46l40.negative_coping_programs", datasource = params$datasource, n = 5)
If yes, what programs?
plot_text(datalist, dico, "group_xt46l40.types_of_programs", datasource=params$datasource)
If yes, how effective are these programs?
plot_select_one(datalist, dico, "group_xt46l40.effectiveness_programs", datasource = params$datasource, n = 5)
Which
protection integrated programme is serving your community
plot_select_multiple(datalist, dico, "group_xt46l40.protection_integrated_programs", datasource=params$datasource, n=5)
Community experienced armed conflict in the last 6 months
plot_select_one(datalist, dico, "group_xt46l40.armed_conflict", datasource = params$datasource, n = 5)
If
yes, what type of armed conflict was it? (Select all that apply)
plot_select_multiple(datalist, dico, "group_xt46l40.conflict_types", datasource=params$datasource, n=5)
If Other ? Please specify
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_003", datasource=params$datasource)
Were
there any civilian casualties during the conflict? (Select all that
apply)
plot_select_multiple(datalist, dico, "group_xt46l40.civilian_casualties", datasource=params$datasource, n=5)
If Other ? Please specify.
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_004", datasource=params$datasource)
What was the effect of the conflict on affected civilians? (Select one)
plot_select_one(datalist, dico, "group_xt46l40.conflict_effect", datasource = params$datasource, n = 5)
Civilian
objects/properties impacted by the conflict
plot_select_multiple(datalist, dico, "group_xt46l40.civilian_objects", datasource=params$datasource, n=5)
If Other ? Please specify..
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_005", datasource=params$datasource)
For Other ?? Please specify.
plot_select_one(datalist, dico, "group_xt46l40.For_Other_Please_specify", datasource = params$datasource, n = 5)
Consequencees of the attacked on the civilian object (Civilian homes)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_ject_Civilian_homes", datasource = params$datasource, n = 5)
Consequencees of the attacked on the civilian object (Population
settlement)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_opulation_settlement", datasource = params$datasource, n = 5)
What are the consequencees of the attacked on the civilian object
(Hospital)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_ian_object_Hospital", datasource = params$datasource, n = 5)
What are the consequencees of the attacked on the civilian object
(School)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_ilian_object_School", datasource = params$datasource, n = 5)
What are the consequencees of the attacked on the civilian object (IDP
Camp)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_ian_object_IDP_Camp", datasource = params$datasource, n = 5)
Consequencees of the attacked on the civilian object (Aid distribution
centers)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_distribution_centers", datasource = params$datasource, n = 5)
Consequencees of the attacked on the civilian object (Reception center)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_ct_Reception_center", datasource = params$datasource, n = 5)
Consequencees of the attacked on the civilian object (Religious
Facility)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_Religious_Facility", datasource = params$datasource, n = 5)
Consequencees of the attacked on the civilian object (Water
facility/boreholes)
plot_select_one(datalist, dico, "group_xt46l40.What_are_the_consequ_r_facility_boreholes", datasource = params$datasource, n = 5)
Were the people in need able to access the partners/organizations?
(Select one)
plot_select_one(datalist, dico, "group_xt46l40.access", datasource = params$datasource, n = 5)
What do you do as a community, to protect yourself during armed
conflict?
plot_text(datalist, dico, "group_xt46l40.community_protection", datasource=params$datasource)
Has the presence of ATMIS FOB impacted your life in any way
plot_select_one(datalist, dico, "group_xt46l40.atm_presence", datasource = params$datasource, n = 5)
If
Yes ? Select all that apply.
plot_select_multiple(datalist, dico, "group_xt46l40.If_Yes_Select_all_that_apply", datasource=params$datasource, n=5)
If Other ? Please specify..
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_006", datasource=params$datasource)
Concerns on the closure of ATMIS Forward Operating Bases (FOBs) in your
area
plot_select_one(datalist, dico, "group_xt46l40.atm_closure", datasource = params$datasource, n = 5)
If Other ? Please specify..
plot_text(datalist, dico, "group_xt46l40.If_Other_Please_specify_007", datasource=params$datasource)
Give reasons for Yes or No.
plot_text(datalist, dico, "group_xt46l40.closure_reasons", datasource=params$datasource)
Efforts of the hum community in addressing protection risks in your area
plot_select_one(datalist, dico, "group_xt46l40.perception", datasource = params$datasource, n = 5)
Recommendations for improving humanitarian assistance and protection
plot_text(datalist, dico, "group_xt46l40.recommendations_improvement", datasource=params$datasource)
would you like to receive an update?
plot_select_one(datalist, dico, "group_xt46l40.update", datasource = params$datasource, n = 5)
No
significant text for the question:
group_xt46l40.phone_numberNULL
Summary Likert Charts
2 groups of likert questions in the
formplot_likert(datalist, dico, scopei="group_xt46l40", list_namei="fh0oh18", repeatvari="main",datasource=params$datasource)
plot_likert(datalist, dico, scopei="group_xt46l40.How_effective_do_you_denial_of_assistance", list_namei="hb8kc42", repeatvari="main",datasource=params$datasource)
Annex: Crunching step
This data crunching report allows to quickly explore the results of the survey published in RIDL. It can be regenerated as needed based on the analysis plan you did set up. The objective of this report is to allow to quickly identify potential patterns in your dataset. A quick screening of this initial report should allow to select the most meaningful graphs.
The crunching process produces a lot of visuals. Therefore it is key to carefully select the most relevant visual that will be presented for potential interpretation in the next step. To do so, you simply copy-paste the short syntax in a second notebook to generate as powerpoint presentation. A typical data interpretation session shall not last more than 2hours and include more than 60 visuals to look at in order to keep participants with a good focus level.
In order to guide this selection phase, data experts, in collaboration with the data analysis group, can use the following elements:
For numeric value, check the frequency distributions of each variable to average, deviation, including outlier and oddities
For categorical variables, check for unexpected values: any weird results based on common sense expectations
Use correlation analysis to check for potential contradictions in respondents answers to different questions for identified associations (chi-square)
Always, Check for missing data (NA) or “%of respondent who answered” that you cannot confidently explain
Check unanswered questions, that corresponds to unused skip logic in the questionnaire: For instance, did a person who was never displaced answer displacement-related questions? Were employment-related answers provided for a toddler?
When analyzing those representations in a collective setting during data interpretation sessions, you may:
Reflect: question data quality and/or make suggestions to adjust questions, identify additional cleaning steps;
Interpret: develop qualitative interpretations of data patterns;
Recommend: suggest recommendations in terms of programmatic adjustment;
Classify: define level of sensitivity for certain topics if required;
The report can be regenerated as needed by:
adjusting the report configuration in the xlsform to break it into report and chapter;
configuring disaggregation & correlation for each question;
revising the data cleansing based on the cleaning log;
appending calculated indicators to your data frame to reshape variable - also called feature engineering.